select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Beaded and Ruched Teal Ball Gown Sweet 15 Dresses with Ruffles
Red Ball Gown Taffeta Dresses for 15 with Pick ups and Embroidery
Laura Linney Teal and Green Ball Gown Sweet 15 Dresses with Ruffles Appliques
Light Green Embroidery Sweet 15 Dresses with Golden Hem
Appliqued Dark Purple Pleated Quinceanera Gowns with Pick-ups
Custom Made Beading Embroidery Dress for Quince with Pick-ups
Colorful Ruched Quinceanera Dresses with Ruffles and Appliques
Lilac and Ivory Dress for Quince with Embroidery and Bowknot
Coral Red Long Sleeves Beading Quinces Dresses with Appliques
Popular Orange Beading Appliqued Dress for Quince with Ruches
Light Purple Ruched Quinceanera Dresses with Colorful Appliques
Lovely Lavender Organza Beading Dress for Sweet 15 with Sequins
Unique Lilac and Black Multi-Layered Pleated Sweet 16 Dresses
Light Purple and White Ruffled Quince Dresses with Hand Made Flowers
Pink One Shoulder Ruched Dress for Quince with Pick-ups
Coral Red Sweetheart Sweet 16 Dresses with Embroidery and Tiers
Simple White Strapless Quinceanera Dresses with Blue Appliques
Fashionable Leopard Printing Dresses for a Quinceanera with Beading
Appliques Sweetheart Pick-ups Quinceanera Party Dresses in Green
Beautiful Beaded Print Dresses for Quince with Pick-ups and Ruffles
Strapless Organza Quinceanera Gown with Ruffled Layers a La Mode
Uniques Ball Gown Strapless Appliques Dresses for Quince for 2014
Modest Strapless Quinceanera Dresses with Appliques on Promotion
Gorgeous Ball Gown Sweetheart Appliques Quince Dresses in Purple
Princess Sweetheart Lilac Quinceanera Dress for Girls Sweet 15
Exquisite A-line Sweetheart Quinceanera Gowns with Dropped Waist
Classy Dark Blue Strapless Quinceanera Gown with Embroidery
Most Elegant Lilac Strapless A-line Quinceanera Dress in Fashion
Beaded Yellow Green Organza Dresses Quinceanera with Sweetheart
Embroidered Olive Green Dresses Quinceanera with Pick ups 2013